File:productView.html
Method:query.map(columns,*where,*order)
第 1 行: '0' 附近有语法错误。
select top 1 * FROM goods_goods WHERE GoodsId=a[0]
数据库执行错误
xmls/product.xmls
...ogPath=[".{@CatalogId}."];
@TagIds=[",{@TagIds},"];
@querygoods[TagIds]=@TagIds;
@querygoods[CatalogPath]=@CatalogPath;
@AreaId=$shell[AreaId];
@querygoods[AreaId]=@AreaId;
@tablegs=@querygoods.table(*,['Status>0 and TagIds like {#like(%TagIds%)} and AreaId={*AreaId}'],['Grade desc,GoodsId asc'],4);
@goodlist=@tablegs.format(@format);
$return(@goodlist);
}
//------------------------查询内容
$sub GoodsDetails(){
@querygoods=$query(goods,goods);
@querygoods[GoodsId]=$http.get(id);
@rowgoods=@querygoods.map(*,['GoodsId={*GoodsId}']);
@economize=0;
@collectCount=0;
$if(@rowgoods==$null){
@rowgoods=$map();
$write(['<script>history.back();</script>']);
$end;
}
$else{
@economize=(@rowgoods[OriginalPrice]-@rowgoods[Price]);
//查询已收藏
@userid=$http.getSession(UserId);
$if(@userid<>$null){
@collectQuery=$query(collect,user);
@collectQuery[UserId]=@userid;
@collectQuery[GoodsId]=@rowgoods[GoodsId];
@collectQuery[GoodsType]=1;
@collectCount=@collectQuery.scalar(['coun...